﻿<?xml version="1.0" encoding="utf-8" ?> 
<AdoNetDataAccess connection="$ArticleDBConnection$" formatter="bizobj of ArticleKeywordSet">

	<Sql>
		SELECT
			ArticleKeywordSets.id, ArticleKeywordSets.name
		FROM
			ArticleKeywordSets INNER JOIN ArticleKeyworkAutoMatches ON ArticleKeywordSets.id = ArticleKeyworkAutoMatches.setId
		WHERE
			(ArticleKeywordSets.companyId = @companyId) AND 
			(ArticleKeyworkAutoMatches.articleId = @articleId) AND 
			(ArticleKeywordSets.name = @name)
	</Sql>
	<Param name="companyId" type="UniqueIdentifier" />
	<Param name="articleId" type="UniqueIdentifier" />
	<Param name="name" type="String" />
</AdoNetDataAccess>
